<?php
/**
 * @package		Joomla.Site
 * @subpackage	mod_users_latest
 * @copyright	Copyright (C) 2005 - 2013 Open Source Matters, Inc. All rights reserved.
 * @license		GNU General Public License version 2 or later; see LICENSE.txt
 */

// no direct access
defined('_JEXEC') or die;

class modUsersLatestHelper
{
    // get users sorted by activation date
    static function getUsers($params)
    {
        $db		= JFactory::getDbo();
        $query	= $db->getQuery(true);
        $query->select('a.id, a.name, a.username, a.registerDate, p.playerid, p.avatar');
        $query->order('a.registerDate DESC');
        $query->from('#__users AS a');
        //$query->where('chesstype = 1');
        $user = JFactory::getUser();
        if (!$user->authorise('core.admin') && $params->get('filter_groups', 0) == 1)
        {
            $groups = $user->getAuthorisedGroups();
            if (empty($groups))
            {
                return array();
            }
            $query->leftJoin('#__user_usergroup_map AS m ON m.user_id = a.id');
            $query->leftJoin('#__usergroups AS ug ON ug.id = m.group_id');
            $query->where('ug.id in (' . implode(',', $groups) . ')');
            $query->where('ug.id <> 1');
        }
        $query->innerJoin('#__player AS p ON p.userid = a.id');
        $db->setQuery($query, 0, $params->get('shownumber'));
        $result = $db->loadObjectList();
        return (array) $result;
    }
}
